package com.cs.beneficios.web.action;
import com.cs.paoyer.administration.business.model.UserVO;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
//import org.apache.struts.action.ActionError;
//import org.apache.struts.action.ActionErrors;
import java.io.IOException;
import javax.servlet.ServletException;
import com.cs.beneficios.common.ConnectionFactory;
import java.sql.Connection;
import javax.servlet.http.HttpSession;

public class EliminarSedeAction extends Action 
{
  /**
   * This is the main action called from the Struts framework.
   * @param mapping The ActionMapping used to select this instance.
   * @param form The optional ActionForm bean for this request.
   * @param request The HTTP Request we are processing.
   * @param response The HTTP Response we are processing.
   * @return 
   * @throws java.io.IOException
   * @throws javax.servlet.ServletException
   */
  public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
  {
   //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
   ConnectionFactory cf = new ConnectionFactory();
   //database db = new database();
   Connection conn = null;
   HttpSession session = request.getSession();
  
  try{              
          conn = cf.getConnection();
          //conn = db.getConnectionWithDriver("beneficios","beneficios");
        }catch (SQLException e){
//            System.out.println("Error al realizar la conexi�n" + e.getMessage());
        }
    String strcodsede = request.getParameter("Codigo");
    
    //Proceso para la auditoria
      UserVO user = (UserVO) request.getSession().getAttribute("userInfo");
      String terminalAddress = request.getRemoteAddr();
      String strTerminal = ("WEB="+terminalAddress);
      Calendar c = Calendar.getInstance(); 
      SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");   
      //Fin del proceso
    
    String strSql = " update  tcs_ben_sede set vigencia = 'I' ,"+
                    " USUARIO_MODIFICA = ?, FECHA_MODIFICA = to_date(?,'dd/mm/yyyy'), "+
                    " TERMINAL_MODIFICA = ? "+
                    " where codigo = ? ";
    String strPar[] = {user.getName(), dateFormat.format(c.getTime()),strTerminal,strcodsede};
    
    
        try{
            int modificar = cf.execSql(strSql,strPar,conn);
              if(modificar > 0){
                  session.setAttribute("mensajes","La sede fue desactivada!!!");
                  }
                 }
               catch(SQLException e)
                 {
					System.err.println("/******** TDSUB - cwsub");
					e.printStackTrace();
					System.err.println("TDSUB - cwsub ********/");
                  session.setAttribute("mensajes","No fue posible desactivar la Sede!!!");
                 }    
       try{
          cf.closeConnection(conn);
       }catch (SQLException e)
       {
		System.err.println("/******** TDSUB - cwsub");
		e.printStackTrace();
		System.err.println("TDSUB - cwsub ********/");
       }
        // db.closeConnection(conn);
    
    
    return mapping.findForward("success");
  }
}